USE [MMS]
GO

/****** Object:  Trigger [dbo].[TR_AS_INSERT_ASSET]    Script Date: 12/03/2012 23:07:24 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TRIGGER [dbo].[TR_AS_INSERT_ASSET] ON [dbo].[MMS_ASSET] 
  AFTER INSERT AS
BEGIN

  SET NOCOUNT ON;
  UPDATE [dbo].[MMS_ASSET] 
  SET CreateDate = getdate() 
  WHERE id = (select top 1 id from [dbo].[MMS_ASSET] order by id desc)

END
GO


